package com.kevin.ymqquan.constants;

public class Constants {

//	public static final String ServerAddr1 = "http://121.42.46.94/";
//	public static final String ServerAddr = "http://192.168.1.111//index.php/welcome/index";
	public static final String ServerAddr = "http://www.ymqquan.com/action/Android/doInit";
	// public static final String ServerAddr1 = "http://192.168.1.52/";
//	 public static final String ServerAddr = ServerAddr1 +
//	 "liaodajiaowu/manage/public/Httppostdata/";
	// public static final String ServerAddr2 = ServerAddr1 +
	// "liaodajiaowu/manage/public/Httppostmessage";
//	public static final String ServerAddr = ServerAddr1
//			+ "ldjw/manage/public/Httppostdata/";
//	public static final String ServerAddr2 = ServerAddr1
//			+ "ldjw/manage/public/Httppostmessage";
	// public static final String ServerAddr = ServerAddr1 +
	// "success/index.php";

	public static final int LOGIN_PARAM = 101;

	// �γ̱�-��ȡ�γ̱�
	public static final int TASK_TECOFFICE_SCHEDULE_GETCOURSE = 51;
	// �γ̱�-��ȡ��ǰ����
	public static final int TASK_TECOFFICE_SCHEDULE_GETWEEK = 52;
	// �γ̱�-��ȡ��ʦ����
	public static final int TASK_TECOFFICE_SCHEDULE_DETAIL_GET = 53;
	// �γ̱�-�ύ��ʦ����
	public static final int TASK_TECOFFICE_SCHEDULE_DETAIL_SEND = 54;
	/* ������ */
	// ...
	public static final String RESULT_TYPE_NG = "-1";
	// �ɹ�
	public static final String RESULT_TYPE_SUCCESS = "0";
	// ʧ��
	public static final String RESULT_TYPE_FAILURE = "1";
	// �ѵ����
	public static final String RESULT_TYPE_PRAISED = "2";
	/* SharedPreferences��� */
	public static final String PREFERENCES_SCHEDULE = "schedule";

	public static final int freeClassId = 1;
	public static final int markLoaderId = 2;
	public static final int scoreLoaderId = 3;
	public static final int printLoaderId = 4;
	public static final int interactionLoaderId = 5;
	public static final int sendCommentLoaderId = 6;
	public static final int clickLoaderId = 7;
	public static final int examLoaderId = 8;
	public static final int collectLoaderId = 9;
	public static final int detailLoaderId = 10;
	public static final int calLoaderId = 11;
	public static final int delLoaderId = 12;
	public static final int yearLoaderId = 13;
	public static final int urlLoaderId = 14;

	/**
	 * ��ݿⳣ��
	 */
	public interface DB {
		// ��ݿ����
		public static final String DATABASE_NAME = "TecOffice";
		// ��ݿ�汾
		public static final int DATABASE_VERSION = 1;

		/**
		 * ���ű�
		 */
		public interface TABLES {
			/**
			 * User��
			 */
			public interface USER {
				// ����
				public static final String TABLE_NAME = "user";

				/**
				 * ����
				 */
				public interface FIELDS {
					// �û������--һ��Ҫ�봴����ʱ������һ��
					public static final String USER_ID = "userId";
					// �û�������
					public static final String USER_PASSWORD = "passWord";
					// ѧ��
					public static final String STU_NUMBER = "stuNumber";
					// ����
					public static final String USER_NAME = "userName";
					// �Ա�
					public static final String USER_SEX = "userSex";
					// ����
					public static final String USER_AGE = "userAge";
					// �绰
					public static final String USER_TEL = "userTel";
					// ѧԺ
					public static final String USER_COLLAGE = "userCollage";
					// רҵ
					public static final String USER_MAJOR = "userMajor";
					// �༶
					public static final String USER_GRAGE = "userGrage";
					// ��ѧ���
					public static final String USER_ENTRA_YEAR = "userEntraYear";

				}

				/**
				 * ���SQL���
				 */
				public interface SQL {
					// ����User��
					public static final String CREATE = "Create  TABLE if not exists user("
							+ "[userId] varchar(20) PRIMARY KEY NOT NULL"
							+ ",[passWord] varchar(20)"
							+ ",[stuNumber] varchar(20)"
							+ ",[userName] varchar(20)"
							+ ",[userSex] integer"
							+ ",[userAge] integer"
							+ ",[userTel] varchar(20)"
							+ ",[userCollage] varchar(20)"
							+ ",[userMajor] varchar(20)"
							+ ",[userGrage] varchar(20)"
							+ ",[userEntraYear] integer" + ");";

					// ɾ��User��
					public static final String DROP = "DROP TABLE IF EXISTS user";
					// �������--��{..}ռλ��ʱǰ�����\"
					public static final String INSERT = "Insert  Into user ([userId],[passWord],[stuNumber],[userName],[userSex],[userAge],"
							+ "[userTel],[userCollage],[userMajor],[userGrage],[userEntraYear]) "
							+ "Values(\"{0}\",\"{1}\",\"{2}\",\"{3}\",\"{4}\",\"{5}\",\"{6}\",\"{7}\",\"{8}\",\"{9}\");";
					// ���id��ѯUser
					public static final String SELECT_BY_USERID = "select * from user where userId=\"{0}\"";
					// ��ѯ����User
					public static final String SELECT_ALL = "select * from user";
					// ���User�ֶ�
					// public static final String UPDATE =
					// "alter table User add sex varchar(8)";
				}
			}

			/**
			 * Schedule��
			 */
			public interface SCHEDULE {
				// ����
				public static final String TABLE_NAME = "schedule";

				/**
				 * ����
				 */
				public interface FIELDS {
					// �γ�ID
					public static final String SCHEDULE_ID = "scheduleId";
					// �γ����
					public static final String SCHEDULE_NAME = "scheduleName";
					// �γ̿�ʼʱ��
					public static final String SCHEDULE_BEGIN_TIME = "scheduleBeginTime";
					// �������
					public static final String SCHEDULU_HOLD_NUM = "scheduleHoldNum";
					// �ܼ��Ͽ�
					public static final String SCHEDULE_WEEKDAY = "scheduleWeekday";
					// ��˫��
					public static final String SCHEDULE_SDWEEK = "scheduleSDWeek";
					// ����ڼ���
					public static final String SCHEDULE_LASTTIME = "scheduleLastTime";
					// ��ʦ����
					public static final String SCHEDULE_TECNAME = "scheduleTecName";
					// �Ͽεص�
					public static final String SCHEDULE_ADDRESS = "scheduleAddress";
					// �Ƿ�����
					public static final String SCHEDULE_WARNFLAG = "scheduleWarnFlag";
					// ��ӦUserId
					public static final String SCHEDULT_USER_ID = "scheduleUserId";

				}

				/**
				 * ���SQL���
				 */
				public interface SQL {
					// ����Schedule��-scheduleAddFlag 1:�����ȡ 2:�ֶ����
					public static final String CREATE = "Create  TABLE if not exists schedule("
							+ " [scheduleUniqueId] integer(4) PRIMARY KEY NOT NULL"
							+ ",[scheduleId] varchar(20)"
							+ ",[scheduleNum] integer"
							+ ",[scheduleName] varchar(20)"
							+ ",[scheduleStartWeek] integer"
							+ ",[scheduleEndWeek] integer"
							+ ",[scheduleSection] integer"
							+ ",[scheduleHoldNum] integer"
							+ ",[scheduleWeekday] integer"
							+ ",[scheduleLastTime] integer[]"
							+ ",[scheduleTecName] varchar(20)"
							+ ",[scheduleAddress] varchar(20)"
							+ ",[scheduleWarnFlag] integer"
							+ ",[scheduleAddFlag] integer"
							+ ",[scheduleRemark] varchar(300)" + ");";
					// ɾ��schedule��
					public static final String DROP = "DROP TABLE IF EXISTS schedule";
					// �������--��{..}ռλ��ʱǰ�����\"
					public static final String INSERT = "Insert  Into schedule ([scheduleId],[scheduleName],[scheduleBeginTime],[scheduleHoldNum],[scheduleWeekday],[scheduleSDWeek],"
							+ "[scheduleLastTime],[scheduleTecName],[scheduleAddress],[scheduleAddress],[SCHEDULT_USER_ID]) "
							+ "Values(\"{0}\",\"{1}\",\"{2}\",\"{3}\",\"{4}\",\"{5}\",\"{6}\",\"{7}\",\"{8}\",\"{9}\");";
					// ���id��ѯschedule
					public static final String SELECT_BY_SCHEDULE_ID = "select * from schedule where scheduleId=\"{0}\"";
					// ��ѯ����Schedule
					public static final String SELECT_ALL = "select * from schedule";
					// ���Schedule�ֶ�
					// public static final String UPDATE =
					// "alter table Schedule add sex varchar(8)";
				}
			}

		}
	}
}
